const Sequelize = require('sequelize');
module.exports = function(sequelize, DataTypes) {
  return sequelize.define('zb_projectbidinfo', {
    classID: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    treeID: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    ID: {
      type: DataTypes.INTEGER,
      allowNull: false,
      primaryKey: true
    },
    BidName: {
      type: DataTypes.STRING(300),
      allowNull: true
    },
    BidAreas: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    BidCost: {
      type: DataTypes.FLOAT,
      allowNull: true
    },
    Address: {
      type: DataTypes.STRING(400),
      allowNull: true
    },
    Content: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    DatePBStart: {
      type: DataTypes.DATE,
      allowNull: true
    },
    DatePBend: {
      type: DataTypes.DATE,
      allowNull: true
    },
    BidGuid: {
      type: DataTypes.CHAR(36),
      allowNull: true
    },
    DateBidStart: {
      type: DataTypes.DATE,
      allowNull: true
    },
    DateBidEnd: {
      type: DataTypes.DATE,
      allowNull: true
    },
    bzjEndDate: {
      type: DataTypes.DATE,
      allowNull: true
    },
    PBCost: {
      type: DataTypes.FLOAT,
      allowNull: true
    },
    code_zbtzs0: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    code_zbtzs1: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    ExpertCount: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    DateZgsc: {
      type: DataTypes.DATE,
      allowNull: true
    },
    DateFb: {
      type: DataTypes.DATE,
      allowNull: true
    },
    zbstatus: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    CorpHXRCount: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    CorpBM: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    CorpBZJ: {
      type: DataTypes.SMALLINT,
      allowNull: true
    },
    Code_xmk: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    TENDER_PROJECT_CLASSIFY_CODE: {
      type: DataTypes.STRING(7),
      allowNull: true
    },
    UNIFIED_DEAL_CODE: {
      type: DataTypes.STRING(40),
      allowNull: true
    },
    BID_SECTION_CODE: {
      type: DataTypes.STRING(23),
      allowNull: true
    },
    SynRightCode: {
      type: DataTypes.INTEGER,
      allowNull: true
    },
    ResultRightTime: {
      type: DataTypes.DATE,
      allowNull: true
    },
    RecordRightTime: {
      type: DataTypes.DATE,
      allowNull: true
    }
  }, {
    sequelize,
    tableName: 'zb_projectbidinfo',
    schema: 'dbo',
    timestamps: false
  });
};
